Transforms forReportBean


ReportGridExcelTransform

Formal Parameter Type Default Required Description
addExcelFormatInfo BOOLEAN false false Determines whether to add the number formatting information for Excel.
It should be of BOOLEAN type.
addNumberFormatting BOOLEAN true false Whether to add the number formatting on metric values.
containerHeight STRING -1 false Specifies the height (in any measure accepted by the web-browser) of the <div> tag enclosing the grid's table. Only used when the ReportGridTransformImpl.heightMode is set to be fixed.
containerWidth STRING -1 false Specifies the width (in any measure accepted by the web-browser) of the <div> tag enclosing the grid's table. Only used when the ReportGridTransformImpl.widthMode is set to be fixed.
cssBottom STRING bottom false

Deprecated. css formatting is now applied through the layout-xml


This is the css name for the bottom area of the transform.
Allowed Values: String value representing a css class name. It should be defined in a css file included in the page.
cssCenter STRING center false

Deprecated. css formatting is now applied through the layout-xml


This is the css name for the center area of the transform.
Allowed Values: String value representing a css class name. It should be defined in a css file included in the page.
cssErrorMessage STRING error-message false

Deprecated. This formal parameter is not referenced anywhere in the code


This is the css name for the error message.
Allowed Values: String value representing a css class name. It should be defined in a css file included in the page.
cssErrorTitle STRING error-title false

Deprecated. This formal parameter is not referenced anywhere in the code


This is the css name for the error title.
Allowed Values: String value representing a css class name. It should be defined in a css file included in the page.
cssFile STRING   false CSS file that includes the style definition.
If defined, this file will be included as Link.
cssLeft STRING left false

Deprecated. css formatting is now applied through the layout-xml


This is the css name for the left area of the transform.
Allowed Values: String value representing a css class name. It should be defined in a css file included in the page.
cssParentFontSize FLOAT 10.0 false This is the report's base font size.
Used when generating the report's CSS classes with the WebCSSHelper.
Allowed Values: positive integer values.
cssPathParameter STRING mstrWeb . false Determines the CSS class path to for all CSS classes in a grid report.
This class will be appended as a prefix to all the CSS classes generated by the WebCSSHelper with a '.' at the beginning
cssPrefix STRING   false Prefix to append to all css class names.
cssRight STRING right false

Deprecated. css formatting is now applied through the layout-xml


This is the css name for the right area of the transform.
Allowed Values: String value representing a css class name. It should be defined in a css file included in the page.
cssTop STRING top false

Deprecated. css formatting is now applied through the layout-xml


This is the css name for the top area of the transform.
Allowed Values: String value representing a css class name. It should be defined in a css file included in the page.
cssUseFileContent BOOLEAN false false This is the flag used in the transform to specify whether to show a link to the CSS file or the whole CSS file content.
Allowed Values: TRUE/FALSE.
cssUseRelativeFont BOOLEAN false false Determines whether to use relative font for the CSS.
Used when generating the report's CSS classes with the WebCSSHelper.
It should be of BOOLEAN type.
customJavaScriptFeatures STRING   false name for the formal parameter "customJavaScriptFeatures".
datasetID STRING   false  
datasetName STRING   false  
debugErrorFlags INTEGER 65535 false Indicates which extra debug information to include in case of an error.
The flags are taken from the EnumWebAppDebugFlags enumeration.
debugFlags INTEGER 0 false Indicates which debug information to include.
The flags are taken from the EnumWebAppDebugFlags enumeration.
extraInput STRING   false Indicates any extra inputs to be included in the forms generated by the transform.
extraUrl STRING   false Indicates any extra parameters to be included in the links generated by the transform.
forceHeadersAndTitlesAsTextForExcel BOOLEAN false false Determines whether to force the headers and titles to be text for Excel.
It should be of BOOLEAN type.
forceMetricValuesAsTextForExcel BOOLEAN false false Determines whether to force the metric values to be text for Excel.
It should be of BOOLEAN type.
globalCssErrorMessage STRING error-message false

Deprecated. The css class to use for the title cannot be controlled by a Formal Parameter anymore.


CSS to be used in all error messages.
globalCssErrorTitle STRING error-title false

Deprecated. The css class to use for the title cannot be controlled by a Formal Parameter anymore.


CSS to be used in all Error titles.
gridClassesConfFile STRING gridClasses.properties false It is used to indicate the name and location of the properties file containing the definition of the grid classes to use.
gridGraphUnitKeyContext STRING   false This formal parameter indicates the unique Id of the RWGridGraphControl. This will only apply to grids and graphs rendered inside Report Writing Documents. Allowed values:
Any String
groupContextMenuDrillPathsByType BOOLEAN false false Determines whether drill types (up, down, across and to template) will be displayed as read from the backend in which case the drill types may be intermingled or that we will buck the types together and show the types grouped together. The order will be up, down, across and to template. Default is false. Allowed Values: TRUE/FALSE.
headerMetricValueOptimized BOOLEAN true false This is the parameter which decides if we move the common html attributes of non-metric headers and metric value cells to a map and is thus stored once. Allowed Values: TRUE/FALSE.
height STRING   false Indicates the default height of the component. If this is not a resizable component, this is the height used. If if it resizable, though, the user might change its width using javascript and the value is saved in a preference; thereafter the Transform will use this new value for this component.
heightMode INTEGER -1 false

Determines whether the <div> tag enclosing the grid should have a fixed height, or should expand to fit the height of the grid's content.

Allowed values:
  • 0-Fixed
  • 2-Fit to contents
When the height is set to be fixed, then the ReportGridTransformImpl.containerHeight property must also be specified.
hideMetricsLabel BOOLEAN false false Hides the 'Metrics' label on the grid's titles.
Allowed Values: TRUE/FALSE.
id STRING   false It is used to identify the outer shell for all report modes - grid, graph and gridgraph. (Firefox issue: 246019)
ignoreSubtotal BOOLEAN false false It is used in the transform to specify whether to display subtotal cells.
Allowed Values: TRUE/FALSE.
imgError STRING jobError.gif false This is the Image to display when there bean is in Error status.
Allowed Values: The value to indicate should be a valid image file name, with any necessary path information not included already on the resourcesFolderImage application configuration parameter.
imgRightDown STRING arrow_rightdown.gif false

Deprecated.


This is the image name for pivot-to-cols image used in the transform.
Allowed values: a valid image file name, with any necessary path information not included already on the resourcesFolderImage application configuration parameter.
imgWait STRING ani_wait.gif false

Deprecated. This value is not used anymore by the Transform as the wait image is included using css.


Name of the image for the Processing icon on the Wait page.
Allowed Values:
The value to indicate should be a valid image file name, with any necessary path information not included already on the resourcesFolderImage application configuration parameter.
initialIndent INTEGER 0 false

Deprecated. Indentation is not appended by Transforms anymore.


Indicates the initial indentation of the HTML generated.
isHTMLExport BOOLEAN false false  
maxSortAllowed INTEGER 3 false This is the value used in the transform to specify how many nested sorts will be allowed in the report.
Allowed Values: positive integer values.
overflowMode INTEGER 0 false

If the ReportGridTransformImpl.widthMode or ReportGridTransformImpl.heightMode is set to be fixed, this parameter specifies what should happen with the <div>'s content if it overflows the space specified by the ReportGridTransformImpl.containerHeight or ReportGridTransformImpl.containerWidth parameters.

Allowed values:
  • 0-Clipped: The content is clipped, and it's not visible
  • 1-Scroll: The content is clipped but scrollbars are enabled.
postTextForMetricValue STRING   false This is the post text for the metric value cell content. Most likely used with exporting feature.
Allowed Values: String values.
postTextForNonMetricValue STRING   false This is the post text for the non-metric value cell content. Most likely used with exporting feature.
Allowed Values: String values.
preTextForMetricValue STRING   false This is the pre text for the metric value cell content. Most likely used with exporting feature.
Allowed Values: String values.
preTextForNonMetricValue STRING   false This is the pre text for the non-metric value cell content. Most likely used with exporting feature.
Allowed Values: String values.
quickSwitch BOOLEAN false false This formal parameter indicates if the grid is going to have the Quick Switch functionality (client side view mode change enabler) enabled. This will only apply to grids and graphs rendered inside Report Writing Documents. Allowed values:
True and False
returnReplacement STRING   false This is the substring that when found in the cell will be replaced by a break (<br>) tag.
Allowed Values: String values.
scriptClass STRING   false Holds the name of the javaScript class (if any) to be associated with the component. When the scriptClass is specified, a bone is registered on the page for this component. A bone is the corresponding concept of a bean in Microstrategy's javascript environment.
By default, thie methods returns an empty string. Transform which does have an associated bone needs to override this method.
showBanding BOOLEAN false false

Deprecated.


It is used in the transform to specify whether to show banding. It only applies to reports that don't use built-in formattings (i.e. reports from old projects).
Allowed Values: TRUE/FALSE.
showContextMenus BOOLEAN true false

Deprecated. This formal parameter is not referenced anywhere in the code. Use isContextMenuEnabled instead


It is used in the transform to specify whether to enable context menu functionality.
Allowed Values: TRUE/FALSE.
showDescriptionAsTooltip INTEGER 0 false It is used in the transform to specify whether to show the descriptions in the tooltip for the row or column titles.
It should be of BOOLEAN type.
Allowed Values: "1" means TRUE, "0" means FALSE.
showGridInFullWidth BOOLEAN true false

Deprecated.


It is used in the transform to specify whether to show the grid in full width.
If TRUE, the grid will expand to the complete browser window; If FALSE, the grid will fit to the content in each cell. Allowed Values: TRUE/FALSE.
showIncreFetchForColumn BOOLEAN true false

Deprecated.


It is used in the transform to specify whether to show increfetch links on column.
Allowed Values: TRUE/FALSE.
showIncreFetchForRowOnBottom BOOLEAN true false

Deprecated.


It is used in the transform to specify whether to show increfetch links for rows at the bottom of the grid.
Allowed Values: TRUE/FALSE.
showIncreFetchForRowOnTop BOOLEAN false false

Deprecated.


It is used in the transform to specify whether to show increfetch links for rows on top of the grid.
Allowed Values: TRUE/FALSE.
showSubtitle STRING 3 false Controls whether subtitles (attribute forms) are to be displayed for this grid. Allowed Values:
showUniqueDrillPaths BOOLEAN false false It is used in the transform to specify whether to show unique drill paths on context menus.
Allowed Values: TRUE/FALSE.
sortSetNamesAndDrillPaths BOOLEAN false false It is used in the transform to specify whether to show the set names and drill paths names alphabetically sorted.
Allowed Values: TRUE/FALSE.
treeType STRING 1 false  
useBuiltInFormat BOOLEAN true false This is the flag used in the transform to specify whether to use the formatting info from the report definition.
Out of box, we map the first preference in Grid preferences section to this formal parameter.
If it's TRUE, WebCSSHelper.getCSS() will give the css class definitions, which is from report formatting defintion.
If it's FALSE, a specified css file will give the css class definitions, which is what formal paramter cssFile means.
Allowed Values: TRUE/FALSE.
useDHTML BOOLEAN true false Indicates whether to use DHTML on the output.
If not set, the bean's OutputFormat() method will be used.
useImageOnEmptyCells BOOLEAN false false It is used in the transform to specify the use of transparent image on empty metric cells.
Allowed Values: TRUE/FALSE.
It is recommended for this formal paramter to be set to false, as using images for empty cells might degrade performance.
width STRING   false Indicates the default width of the component. If this is not a resizable component, this is the width used. If if it resizable, though, the user might change its width using javascript and the value is saved in a preference; thereafter the Transform will use this new value for this component.
widthMode INTEGER -1 false

Determines whether the <div> tag enclosing the grid should have a fixed width, or should expand to fit the width of the grid's content.

Allowed values:
  • 0-Fixed
  • 2-Fit to contents
When the width is set to be fixed, then the ReportGridTransformImpl.containerWidth property must also be specified.
wrapMetricValue BOOLEAN false false This is the parameter which decides if we wrap the metric values cells when displaying the report. It was added to support older browsers that ignore WordWrap in css (which is how the Word Wrap property in the grid formatting dialog works). In newer browsers, the user has complete control. It's usually mapped to the "wrapRowHeader" preference (set at the project level by the administrator) and set through the style catalog. It affects the transform's output as follow:
  1. If true, users with Internet Explorer 5.5 and greater-word wrapping is controlled by the "Wrap text" setting on the Format panel (on the Alignment tab); users with Internet Explorer 5.0 and less and Netscape Navigator 4.7-word wrapping is allowed in all attribute element cells.
  2. When false, users with IE 5.5 and greater-word wrapping for the attribute element cells that are in the rows (on the left of the grid) is not allowed. Word wrapping in all other cells is still controlled by the "Wrap text" setting on the Format panel (on the Alignment tab); users with Internet Explorer 5.0 and below-word wrapping for the attribute element cells that are in the rows (on the left of the grid) is not allowed. Word wrapping is allowed in all other cells.
Allowed Values: TRUE/FALSE.
wrapRowHeader BOOLEAN true false This is the parameter which decides if we wrap the row header cells when displaying the report. It was added to support older browsers that ignore WordWrap in css (which is how the Word Wrap property in the grid formatting dialog works). In newer browsers, the user has complete control. It's usually mapped to the "wrapRowHeader" preference (set at the project level by the administrator) and set through the style catalog. It affects the transform's output as follow:
  1. If true, users with Internet Explorer 5.5 and greater-word wrapping is controlled by the "Wrap text" setting on the Format panel (on the Alignment tab); users with Internet Explorer 5.0 and less and Netscape Navigator 4.7-word wrapping is allowed in all attribute element cells.
  2. When false, users with IE 5.5 and greater-word wrapping for the attribute element cells that are in the rows (on the left of the grid) is not allowed. Word wrapping in all other cells is still controlled by the "Wrap text" setting on the Format panel (on the Alignment tab); users with Internet Explorer 5.0 and below-word wrapping for the attribute element cells that are in the rows (on the left of the grid) is not allowed. Word wrapping is allowed in all other cells.
Allowed Values: TRUE/FALSE.